package org.jeecg.modules.demo.ch.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.demo.ch.entity.ChSoftwareOperationPlan;

import java.util.List;

/**
 * @Description: 软件运维计划表
 * @Author: jeecg-boot
 * @Date:   2022-10-28
 * @Version: V1.0
 */
public interface ChSoftwareOperationPlanMapper extends BaseMapper<ChSoftwareOperationPlan> {

    /**
     * 默认取本月以及下个月到期项目
     *
     *
     * @param pageNo
     * @param pageSize
     * @return
     */
    List<ChSoftwareOperationPlan> selectChSoftwareOperationPlanListByTime(@Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize,@Param("beginTime") String authorizationDeadlineBegin,@Param("endTime") String authorizationDeadlineEnd,@Param("hardBeginTime") String hardwareAuthorizationDeadlineBegin,@Param("hardEndTime") String hardwareAuthorizationDeadlineEnd,@Param("hardExpirBeginTime") String hardExpirBeginTime,@Param("hardExpirEndTime") String hardExpirEndTime,@Param("softExpirBeginTime") String softExpirBeginTime,@Param("softExpirEndTime") String softExpirEndTime);
    /**
     * 默认取本月以及下个月到期项目总数
     * @return
     */
    int selectChSoftwareOperationPlanListTotalByTime(@Param("beginTime") String authorizationDeadlineBegin,@Param("endTime") String authorizationDeadlineEnd,@Param("hardBeginTime") String hardwareAuthorizationDeadlineBegin,@Param("hardEndTime") String hardwareAuthorizationDeadlineEnd,@Param("hardExpirBeginTime") String hardExpirBeginTime,@Param("hardExpirEndTime") String hardExpirEndTime,@Param("softExpirBeginTime") String softExpirBeginTime,@Param("softExpirEndTime") String softExpirEndTime);
}
